﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$UserLoginDBConnection$" formatter="bizobj of UserLimits">
	<Sql>
		SELECT
		<code>
			IBizObjList fields = App.ruleMgr.execute("getUserLimitsDbFields").CallResults as IBizObjList;
			if(fields != null)
			foreach(IBizObj field in fields)
			sql.AppendFormat("{0} as {1},", field.get("dbName"), field.get("aliasName"));
		</code>
		id
		FROM Users
		WHERE id=@userId
	</Sql>

	<Param name="userId" type="UniqueIdentifier"/>
</AdoNetDataAccess>
